Database Lookup/Import

Notes/Domino 8 Forum

Subject: Database Lookup/Import

Feedback Type: Problem

Product Area: Designer Client

Technical Area: Application development

Platform: ALL

Release: All

Reproducible: Always

I'm trying to Import data to populate a view, the data imports into my view but when I try to make a selection from a 'Dialog List' field in the Main Doc I can't see the data and I get the following error: "Keywords must be text!". If I clear the imported data and key in data using the Material Code form in the database it works. The file that I'm importing from is a WKS (1-2-3).

**Main Document Form:
Field called: MaterialCode - Dialog
List/Editable with formula @DbColumn("":"";"":"";"LookupMaterialCode";1)
Field called: MaterialDesc - Text - Computed with formula @If(MaterialCode = ""; "" ;@DbLookup("":"";"":"";"LookupMaterialCode"; MaterialCode; 2))

** Material Code Form:
Field called: MaterialCodeUp - Text/Edit
Field Called: MatericalDescUp - Text/Edit

**LookupMaterialCode View
1st Column: MaterialCodeUp - General
2nd Column: MaterialDescUp - General

** Import File WK3 (1-2-3)
Ist Field: MaterialCodeUp - General
2nd Field: MaterialDescUp - General

I have tried columns as Text, Number, General. ??

Hopefully there is something simple that I'm missing.

Appreciate any help
Regards... Marion

Feedback number WEBB8ZE54R created by ~Chloe Minnulitli on 10/25/2012

Status: Open
Comments: